package com.boc.ewr.business.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Param;
import com.boc.ewr.business.entity.AcctDtlClassD;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Select;

/**
 * @Description: D类账户明细
 * @Author: jeecg-boot
 * @Date:   2023-05-26
 * @Version: V1.0
 */
public interface AcctDtlClassDMapper extends BaseMapper<AcctDtlClassD> {

    //非重点账单中，12月无主动交易账户或3个月无主动交易，时点余额为0的账户
    @Select("select bus.* from ACCT_UNCA_DTL bus where  bus.LAST_THTN_MONS_TRANS = '0' or (bus.LAST_TH_MONS_TRANS = '0' and bus.BALANCE = '0') and bus.PROTOCOL_TYPE in ('1', '2')")
    List<AcctDtlClassD> creatInfo();
}
